package cn.source.school.mapper;

import java.util.List;
import cn.source.school.domain.School;
import cn.source.school.domain.SchoolsmajorsDetail;
import cn.source.subject.domain.SMajorsSubjectVo;
import cn.source.subject.domain.SmSubject;

/**
 * 学校列表Mapper接口
 *
 * @author xuhao
 * @date 2023-12-18
 */
public interface SchoolMapper
{
    /**
     * 查询学校列表
     *
     * @param sid 学校列表主键
     * @return 学校列表
     */
    public School selectSchoolBySId(Long sid);

    /**
     * 查询学校列表列表
     *
     * @param school 学校列表
     * @return 学校列表集合
     */
    public List<School> selectSchoolList(School school);
    
    public List<School> selectSchoolList4Page(School school);

    public List<School> selectSchoolList4PageNotIn(School school);
    
    public List<School> selectSchoolList4H5Page(School school);
    
    public List<School> selectSchoolListByZy4Page(School school);
    
    
    public List<School> selectSchoolListBy2024(School school);

    public List<School> selectSchoolListBy2024NotIn(School school);

    /**
     * 新增学校列表
     *
     * @param school 学校列表
     * @return 结果
     */
    public int insertSchool(School school);

    /**
     * 修改学校列表
     *
     * @param school 学校列表
     * @return 结果
     */
    public int updateSchool(School school);

    /**
     * 删除学校列表
     *
     * @param sid 学校列表主键
     * @return 结果
     */
    public int deleteSchoolBySId(Long sid);

    /**
     * 批量删除学校列表
     *
     * @param sIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteSchoolBySIds(Long[] sIds);


    /**
     * 学院选学科
     * @param scode
     * @return
     */
    List<School> selectschoolMajorList(School scode);

    List<SchoolsmajorsDetail> selectschoolSmajorsList(SchoolsmajorsDetail schoolsmajorsDetail);

    List<School> schoolsmajors(School school);

    List<School> selectSchoolByScode(String scode);

    List<School> selectSchoolBySname(String sname);

    List<SmSubject> selectSubjectMajor(SmSubject subject);

//    public List<School>selectSubjectMajorList(School subject);

}
